USE [NewHis]
GO

/****** Object:  Table [dbo].[ZZ_ORDER]    Script Date: 11/06/2020 08:58:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ZZ_ORDER](
	[orderid] [int] IDENTITY(1,1) NOT NULL,
	[type] [varchar](20) NULL,
	[outTradeNo] [varchar](50) NULL,
	[amount] [decimal](10, 2) NULL,
	[payAmount] [decimal](10, 2) NULL,
	[balancePayment] [decimal](10, 2) NULL,
	[payTime] [datetime] NULL,
	[payType] [nchar](20) NULL,
	[brid] [varchar](20) NULL,
	[fphm] [varchar](50) NULL,
	[createTime] [datetime] NOT NULL,
	[remarks] [varchar](100) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'待缴费订单' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZZ_ORDER'
GO

ALTER TABLE [dbo].[ZZ_ORDER] ADD  CONSTRAINT [DF__ZZ_ORDER__create__20AE6939]  DEFAULT (getdate()) FOR [createTime]
GO


